/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.53-3308
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : 192.168.1.53:3308
 Source Schema         : yygh_hosp

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 09/11/2022 10:45:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hospital_set
-- ----------------------------
DROP TABLE IF EXISTS `hospital_set`;
CREATE TABLE `hospital_set` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `hosname` varchar(100) DEFAULT NULL COMMENT '医院名称',
  `hoscode` varchar(30) DEFAULT NULL COMMENT '医院编号',
  `api_url` varchar(100) DEFAULT NULL COMMENT 'api基础路径',
  `sign_key` varchar(50) DEFAULT NULL COMMENT '签名秘钥',
  `contacts_name` varchar(20) DEFAULT NULL COMMENT '联系人',
  `contacts_phone` varchar(11) DEFAULT NULL COMMENT '联系人手机',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_hoscode` (`hoscode`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 COMMENT='医院设置表';

-- ----------------------------
-- Records of hospital_set
-- ----------------------------
BEGIN;
INSERT INTO `hospital_set` (`id`, `hosname`, `hoscode`, `api_url`, `sign_key`, `contacts_name`, `contacts_phone`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (1, '北京协和医院', '1000_0', 'http://localhost', 'ba27058f8dcbf42c1523b4b7881a1c07', '李玉祥', '15038651933', 1, '2021-08-20 08:07:43', '2022-11-04 06:07:48', 0);
INSERT INTO `hospital_set` (`id`, `hosname`, `hoscode`, `api_url`, `sign_key`, `contacts_name`, `contacts_phone`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (12, '北京协和医院', '1000', 'http://localhost', '98dbe3642941a17ad7dd921a111cd34e', '李玉祥', '15038651933', 1, '2022-11-02 06:10:52', '2022-11-04 06:07:52', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
